﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'GetAllFromVenta')
	BEGIN
		DROP  Procedure  GetAllFromVenta
	END

GO

CREATE Procedure GetAllFromVenta

AS

BEGIN
	SET NOCOUNT ON
	
	SELECT
	V.[Descripcion],
	V.[FechaVenta],
	V.[IdCliente],
	V.[IdEmpleado],
	V.[IdVenta],
	V.[Numero],
	V.[Serie]
	FROM [Venta] AS V
	ORDER BY [IdVenta] DESC

	SET NOCOUNT OFF
END

GO


GRANT EXEC ON GetAllFromVenta TO PUBLIC

GO


